SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweProveedores
AS
SELECT     idProveedor AS ID, RazonSocial, Domicilio, Localidad, Telefono, Interno, Fax, Movil, [E-Mail] AS EMail, Web, Contacto, TelefonoContacto, 
                      MovilContacto, [E-MailContacto] AS EMailContacto, CUIT, IngresosBrutos, CondicionFiscal
FROM         dbo.tb_Proveedores
GO
GRANT SELECT ON  [dbo].[vweProveedores] TO [AdministracionEscolar]
GRANT INSERT ON  [dbo].[vweProveedores] TO [AdministracionEscolar]
GRANT DELETE ON  [dbo].[vweProveedores] TO [AdministracionEscolar]
GRANT UPDATE ON  [dbo].[vweProveedores] TO [AdministracionEscolar]
GRANT SELECT ON  [dbo].[vweProveedores] TO [GestionComprasySuministros]
GRANT INSERT ON  [dbo].[vweProveedores] TO [GestionComprasySuministros]
GRANT DELETE ON  [dbo].[vweProveedores] TO [GestionComprasySuministros]
GRANT UPDATE ON  [dbo].[vweProveedores] TO [GestionComprasySuministros]
GRANT SELECT ON  [dbo].[vweProveedores] TO [GestionContable]
GRANT INSERT ON  [dbo].[vweProveedores] TO [GestionContable]
GRANT DELETE ON  [dbo].[vweProveedores] TO [GestionContable]
GRANT UPDATE ON  [dbo].[vweProveedores] TO [GestionContable]
GRANT SELECT ON  [dbo].[vweProveedores] TO [GestionDeposito]
GRANT INSERT ON  [dbo].[vweProveedores] TO [GestionDeposito]
GRANT UPDATE ON  [dbo].[vweProveedores] TO [GestionDeposito]
GRANT SELECT ON  [dbo].[vweProveedores] TO [GestionInventario]
GRANT UPDATE ON  [dbo].[vweProveedores] TO [GestionInventario]
GRANT SELECT ON  [dbo].[vweProveedores] TO [GestionServiciosEscolares]
GRANT SELECT ON  [dbo].[vweProveedores] TO [GestionSubsidiosyRendiciones]
GRANT SELECT ON  [dbo].[vweProveedores] TO [Informatica]
GRANT INSERT ON  [dbo].[vweProveedores] TO [Informatica]
GRANT DELETE ON  [dbo].[vweProveedores] TO [Informatica]
GRANT UPDATE ON  [dbo].[vweProveedores] TO [Informatica]
GRANT SELECT ON  [dbo].[vweProveedores] TO [SoloVer]
GO
